{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["REG","README"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":25,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"REG","index":0,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Desc","Code",null,"Option Buttons"]
["ACTIVE PATIENTS","REG000",null,1]
["Applied","REG001"]
["Permanent","REG002"]
["Temporary Resident < 16 days","REG003"]
["Temporary Resident 16 days to 3 months","REG004"]
["Transferred Out","REG005"]
["Immediately Necessary Treatment","REG006"]
["Emergency Treatment","REG007"]
["Child Health Surveillance","REG008"]
["Contraception","REG009"]
["Maternity","REG010"]
["Minor Surgery","REG011"]
["Private","REG012"]
["Referred","REG013"]
["Walk in Centre","REG014"]
["GP with Special Interest","REG015"]
["Minor Injury Clinic","REG016"]
["HMP Inmate","REG017"]
["Visitor (EC111)","REG018"]
["INCLUDE ALL","NONE"]

{"sheet":"README","index":1,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[[11,6,15,12],[7,1,7,3],[8,1,8,3]]}
[]
[null,"Child Immunisation Analysis and Open Exeter upload",null,null,null,null,"NOTE:"]
[null,"Last updated: 10/04/2019",null,"Version: 2.7b",null,null,"This will only work if Vision is on DLM485 or above."]
[null,null,null,null,null,null,"Excel 2010 - Please \"Enable Content\" if a security Warning is displayed"]
[null,"Aged","Date","List Date","HA Cipher"]
[null,5,"2019-04-10",{"$f":"DATE(YEAR(C6),FLOOR(MONTH(C6)-1,3)+1,1)","v":"2019-04-01"},null,null,"Excel 2007 - Click the Options button and Enable both Macros and Data Connection"]
[null,null,null,null,null,null,"Excel 2003 - If macros are disabled you will need to enable them via Tools menu > Macro > Security"]
[null,"SELECT REGISTRATION STATUS"]
[null,"INCLUDE ALL",null,null,null,null,"Written by: Bradley Sieve"]
[]
[null,null,null,null,null,null,"Disclaimer"]
[null,null,null,null,null,null,"In using this Microsoft Excel report you hereby acknowledge that the software cannot be guaranteed error free and may also be subject to how data is being recorded by your practice, and further acknowledge that the existence of any such errors shall not make Vision responsible for any actions you carry out based on these results."]
[]
[null,"1.  Define the patient age to search on and registration status"]
[null,"2.  The List Date Qtr is adjusted from the date field"]
[null,"3.  Enter the DATASOURCE or HA Cipher"]
[null,"4.  Click the compile button to start the automatic data extraction from Vision",null,null,null,null,"v2.2 Now only includes GIVEN immunisations in Open Exeter CSV file (IMMS tab)"]
[null,"5.  Once compiled; check the data on the IMMS tab is correct and change accordingly",null,null,null,null,"v2.3 Change made to immunisations under GMS to include \"In another practice\""]
[null,"6.  Then click the \"Prepare Open Exeter CSV file\" button ",null,null,null,null,"v2.4 Change to Excel code to accommodate single GP practice"]
[null,"       A CSV file will be saved to \"P:\\Extract\\$CHILD IMMS\" for upload to Open Exeter",null,null,null,null,"v2.5 Fix applied to Open Exeter CSV button for  XL2007"]
[null,null,null,null,null,null,"v2.6 Fix applied to end date when working out age"]
[null,"Note: ",null,null,null,null,"v2.7 Fix applied to date format in cell C6 being written as mm/dd instead of dd/mm/yyyy"]
[null,"Age is calculated from list date QTR"]
[null,"All immunisations are listed for the single childs age"]
[null,"The GPCODE and DATASOURCE are taken from the patients 'Registered GP' TP/HA/CSA code"]
[null,"Each compile will generate a unique CSV file name using a DATETIME stamp in the file name"]
[]
[null,"This workbook will also show the following child immunisations:"]
[null,"MMR, DTAPIPVHIB or DTAPIPVHIBHB , DTAPIPV, MENC, HIBMENC, MENB, ROTAVIRUS, PNEUMO, FLUSIN"]
[null,"Only MMR, 5IN1 or 6IN1, MENC and Booster are included for Open Exeter upload"]
[]
[null,"Each immunisation stage has its own tab"]
[null,"Each immunisation with multiple stages has an analysis tab that shows:"]
[null,"The status of each stage (given Y/N) and days either side due dates"]
[]
[null,"Immunisations Under GMS"]
[null,"Immunisations with a source of either:"]
[null,"\"In this Practice\" or \"In Another Practice\" will be classed as under GMS and marked with a \"Y\""]
[null,"Those with \"Out of Practice\" or \"Source Unknown\" will not be classed as under GMS and marked with an \"N\""]